﻿/******************************************************   
创建者: 梁家健
创建时间: 2017-03-31
修改:
修改时间: 
功能: 导出店间调拨需求表
 ******************************************************/

using System;
using System.Collections.Generic;
using System.ComponentModel.Composition;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using com.nm.library.Excels;

namespace VerticaAPI.Export
{
    [Export(typeof(ExcelImport))]
    public class DwAllocationRequire : ExcelImport
    {
        public override ExcelImportType Type => ExcelImportType.DWALLOCATIONREQUIRE;
        public override Dictionary<string, ImportVerify> DictFields => _dictFields;

        private static readonly Dictionary<string, ImportVerify> _dictFields = new List<ImportVerify> {
            new ImportVerify{ ColumnName="店铺",FieldName="ShopName",DataType=typeof(string),VerifyFunc =(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,200,true,true)},
            new ImportVerify{ ColumnName="项目",FieldName="ItemName",DataType=typeof(string),VerifyFunc =(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,200,true,true)},
            new ImportVerify{ ColumnName="图片",FieldName="PicUrl",DataType=typeof(string),VerifyFunc =(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,200,true,true)},
            new ImportVerify{ ColumnName="货号",FieldName="MaterialID",DataType=typeof(string),VerifyFunc =(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,200,true,true)},
            new ImportVerify{ ColumnName="城市",FieldName="city_name",DataType=typeof(string),VerifyFunc =(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,200,true,true)},
            new ImportVerify{ ColumnName="最近月份销售",FieldName="MonthSaleQty",DataType=typeof(int),VerifyFunc =(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,50,false,true)},
            new ImportVerify{ ColumnName="货品简称",FieldName="GoodsName",DataType=typeof(string),VerifyFunc =(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,50,false,true)},
            new ImportVerify{ ColumnName="颜色",FieldName="Color",DataType=typeof(string),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,50,false,true) },
            new ImportVerify{ ColumnName="吊牌价",FieldName="TagPrice",DataType=typeof(string),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,50,false,true) },
            new ImportVerify{ ColumnName="上上周销量",FieldName="LastTwoWeekSaleQty" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,50,false,true)},
            new ImportVerify{ ColumnName="上周销量",FieldName="LastWeekSaleQty" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,50,false,true)},
            new ImportVerify{ ColumnName="上市日期",FieldName="SaleDate" ,DataType=typeof(string),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,50,false,true)},
            new ImportVerify{ ColumnName="最近一次调入日期",FieldName="LastMoveDate" ,DataType=typeof(string),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,50,false,true)},
            new ImportVerify{ ColumnName="累计销量",FieldName="TotalSaleQty" ,DataType=typeof(long),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,50,false,true)},
            new ImportVerify{ ColumnName="SKC畅滞销状态",FieldName="SKC_SluggishState" ,DataType=typeof(string),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,50,false,true)},
            new ImportVerify{ ColumnName="累计日均售罄率",FieldName="TotalDaySaleRate" ,DataType=typeof(decimal),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,50,false,true)},
            new ImportVerify{ ColumnName="近一周日均售罄率",FieldName="WeekDaySaleRate" ,DataType=typeof(decimal),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,50,false,true)},
            new ImportVerify{ ColumnName="S",FieldName="MoveRequireQty_S",DataType=typeof(int),VerifyFunc =(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            new ImportVerify{ ColumnName="M",FieldName="MoveRequireQty_M",DataType=typeof(int),VerifyFunc =(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            new ImportVerify{ ColumnName="L",FieldName="MoveRequireQty_L",DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true) },
            new ImportVerify{ ColumnName="XL",FieldName="MoveRequireQty_XL",DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true) },
            new ImportVerify{ ColumnName="XXL",FieldName="MoveRequireQty_XXL" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            new ImportVerify{ ColumnName="3XL",FieldName="MoveRequireQty_3XL" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            new ImportVerify{ ColumnName="4XL",FieldName="MoveRequireQty_4XL" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            new ImportVerify{ ColumnName="JM",FieldName="MoveRequireQty_JM" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            new ImportVerify{ ColumnName="27",FieldName="MoveRequireQty_27" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            new ImportVerify{ ColumnName="28",FieldName="MoveRequireQty_28" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            new ImportVerify{ ColumnName="29",FieldName="MoveRequireQty_29" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            new ImportVerify{ ColumnName="30",FieldName="MoveRequireQty_30" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            new ImportVerify{ ColumnName="31",FieldName="MoveRequireQty_31" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            new ImportVerify{ ColumnName="32",FieldName="MoveRequireQty_32" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            new ImportVerify{ ColumnName="33",FieldName="MoveRequireQty_33" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            new ImportVerify{ ColumnName="34",FieldName="MoveRequireQty_34" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            new ImportVerify{ ColumnName="35",FieldName="MoveRequireQty_35" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            new ImportVerify{ ColumnName="36",FieldName="MoveRequireQty_36" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            new ImportVerify{ ColumnName="37",FieldName="MoveRequireQty_37" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            new ImportVerify{ ColumnName="38",FieldName="MoveRequireQty_38" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            new ImportVerify{ ColumnName="39",FieldName="MoveRequireQty_39" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            new ImportVerify{ ColumnName="40",FieldName="MoveRequireQty_40" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            new ImportVerify{ ColumnName="41",FieldName="MoveRequireQty_41" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            new ImportVerify{ ColumnName="42",FieldName="MoveRequireQty_42" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            new ImportVerify{ ColumnName="43",FieldName="MoveRequireQty_43" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            new ImportVerify{ ColumnName="44",FieldName="MoveRequireQty_44" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            new ImportVerify{ ColumnName="45",FieldName="MoveRequireQty_45" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            new ImportVerify{ ColumnName="需求合计",FieldName="MoveRequireQty_Sum" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="S",FieldName="WeekSaleDetail_S",DataType=typeof(int),VerifyFunc =(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="M",FieldName="WeekSaleDetail_M",DataType=typeof(int),VerifyFunc =(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="L",FieldName="WeekSaleDetail_L",DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true) },
            //new ImportVerify{ ColumnName="XL",FieldName="WeekSaleDetail_XL",DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true) },
            //new ImportVerify{ ColumnName="XXL",FieldName="WeekSaleDetail_XXL" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="3XL",FieldName="WeekSaleDetail_3XL" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="4XL",FieldName="WeekSaleDetail_4XL" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="JM",FieldName="WeekSaleDetail_JM" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="27",FieldName="WeekSaleDetail_27" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="28",FieldName="WeekSaleDetail_28" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="29",FieldName="WeekSaleDetail_29" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="30",FieldName="WeekSaleDetail_30" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="31",FieldName="WeekSaleDetail_31" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="32",FieldName="WeekSaleDetail_32" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="33",FieldName="WeekSaleDetail_33" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="34",FieldName="WeekSaleDetail_34" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="35",FieldName="WeekSaleDetail_35" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="36",FieldName="WeekSaleDetail_36" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="37",FieldName="WeekSaleDetail_37" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="38",FieldName="WeekSaleDetail_38" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="39",FieldName="WeekSaleDetail_39" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="40",FieldName="WeekSaleDetail_40" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="41",FieldName="WeekSaleDetail_41" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="42",FieldName="WeekSaleDetail_42" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="43",FieldName="WeekSaleDetail_43" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="44",FieldName="WeekSaleDetail_44" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="45",FieldName="WeekSaleDetail_45" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="销售合计",FieldName="WeekSaleDetail_Sum" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="S",FieldName="InventoryDetails_S",DataType=typeof(int),VerifyFunc =(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="M",FieldName="InventoryDetails_M",DataType=typeof(int),VerifyFunc =(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="L",FieldName="InventoryDetails_L",DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true) },
            //new ImportVerify{ ColumnName="XL",FieldName="InventoryDetails_XL",DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true) },
            //new ImportVerify{ ColumnName="XXL",FieldName="InventoryDetails_XXL" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="3XL",FieldName="InventoryDetails_3XL" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="4XL",FieldName="InventoryDetails_4XL" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="JM",FieldName="InventoryDetails_JM" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="27",FieldName="InventoryDetails_27" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="28",FieldName="InventoryDetails_28" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="29",FieldName="InventoryDetails_29" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="30",FieldName="InventoryDetails_30" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="31",FieldName="InventoryDetails_31" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="32",FieldName="InventoryDetails_32" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="33",FieldName="InventoryDetails_33" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="34",FieldName="InventoryDetails_34" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="35",FieldName="InventoryDetails_35" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="36",FieldName="InventoryDetails_36" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="37",FieldName="InventoryDetails_37" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="38",FieldName="InventoryDetails_38" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="39",FieldName="InventoryDetails_39" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="40",FieldName="InventoryDetails_40" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="41",FieldName="InventoryDetails_41" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="42",FieldName="InventoryDetails_42" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="43",FieldName="InventoryDetails_43" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="44",FieldName="InventoryDetails_44" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="45",FieldName="InventoryDetails_45" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
            //new ImportVerify{ ColumnName="库存合计",FieldName="InventoryDetails_Sum" ,DataType=typeof(int),VerifyFunc=(e,extra)=> ExcelImportHelper.GetCellMsg(e.CellValue,e.ColName,2,false,true)},
           }.ToDictionary(e => e.ColumnName, e => e);

        public override object SaveImportData(DataTable dt, Dictionary<string, object> extraInfo, int userId)
        {
            throw new NotImplementedException();
        }

        public override DataTable GetExportData(string Keys)
        {
            var handler = new DwAllocationRequireHandler();
            return handler.ExportDwAllocationRequire(Keys);
        }
    }
}
